wedding jewellery - Spanish Wedding Planner

Instead of flowers...

Friday, 26 June 2015 00:00

For some brides a bridal bouquet is an integral part of the Big Day and their wedding would not be complete without a bouquet and floral decoration. However, if flowers aren't your thing, you are allergic to certain pollens or flowers , or you haven't got big money to spend in blooms there are other options.

Spanish fans: Fans are very much a part of the tradition and culture in Southern Spain so carrying a special bridal fan and not a bouquet is a great way to change things up from a traditional bouquet. There are still plenty of small family run companies making incredible ornate fans that work brilliantly as you walk up the aisle so you can choose from lots of colours and styles. Fans usually work out cheaper than bouquets and come in a range of colours so you can coordinate bridesmaids fans with your colour scheme and carry on the fan decoration at your reception venue. Ask your planner for prices and examples.

A book: In years gone by brides sometimes carried a prayer book as they walked into the church. Nowadays though you can buck the bouquet trend AND add special meaning to your wedding by carrying a book which has meaning to you and your fiance. If you have a special poem or novel which means something to you and your story then why not use this instead of bouquet?

A wedding purse: This is not just a great to carry a couple of essential or meaningful items but because you really can go to town to make this match your dress and outfit. You can have the purse made of pretty much any material in any colour, add smaller versions for your bridesmaids and, if you have a close family member who can’t be with you on the day, carry a memento of them with you in your purse so can be with you in spirit.

A wedding broach or piece of jewellery: This can be a long-lasting alternative to a wedding bouquet and something which leaves your hands free too! There are some great jewellery designers who will design something to suit your ideas or you can shop around online to find something off the peg to suit your colour scheme, style and budget.

Remember - ultimately it’s your day and if you don’t want flowers then there are alternatives!

Love Gifts for your Wedding Day

Friday, 10 April 2015 00:00

Your wedding day started out as YOUR wedding day but somewhere along the line you got caught up with the guest list, the meal choices, the decorations and the logistics of getting your friends and family to Spain. The excitement builds and then you fly out and spend a few days getting the last bits and pieces in place. On the Big Day itself it is easy to feel nervous and a bit overwhelmed. One thing that can really put everything back into perspective is a secret gift for your other half….A little gift or note that can be delivered to the hotel/apartment where your future husband/wife is getting ready shows the intimacy you share and that you have thought of them, and them alone, amid a day of friends, family and celebration.

This does not have to be an expensive or traditional gift but something personal with meaning for the two of you that gives you something private to smile about throughout the day. Check out the ideas below for inspiration:

A song that has meaning for you both. OK most of us listen to music on ipods or phones these days but if there’s an old song you both love then find it on vinyl. In particular a 7” can easily be secreted into your suitcase and sent to your fiance with a note on the wedding morning!

Jewellery - there is plenty to choose from but some elegant cufflinks for your man or a pretty bracelet for your wife to be will remind them of the place they hold in your heart.

A Poem or letter - get creative and tell the one you are marrying how they make you feel.

Personalised mugs - a fun memento of your day and a sweet way to enjoy your morning coffee together when you get back home!

A handmade canvas memory of your day - wow your wife or husband to be with a beautiful token of your Big Day.

Check with your wedding planner for more gifts which work well in Spain to remind your future husband or wife of your love for them on the Big Day!

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1731965251,
                "last": 1731965251,
                "now": 1731965251
            },
            "client": {
                "forwarded": "18.117.232.38"
            }
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Profile Information

Time

Memory

Time: 7.81 ms / 7.81 ms Memory: 0.585 MB / 0.95 MB Application: afterLoad

Time: 50.06 ms / 57.86 ms Memory: 0.918 MB / 1.87 MB Application: afterInitialise

Time: 11.78 ms / 69.64 ms Memory: 0.446 MB / 2.31 MB Application: afterRoute

Time: 0.40 ms / 70.05 ms Memory: 0.023 MB / 2.34 MB Application: beforeRenderComponent com_k2

Time: 0.14 ms / 70.19 ms Memory: 0.018 MB / 2.35 MB Application: Before Access::preloadComponents (all components)

Time: 1.20 ms / 71.39 ms Memory: 0.058 MB / 2.41 MB Application: After Access::preloadComponents (all components)

Time: 0.05 ms / 71.44 ms Memory: -0.003 MB / 2.41 MB Application: Before Access::getAssetRules (id:249 name:com_k2)

Time: 0.20 ms / 71.64 ms Memory: 0.009 MB / 2.42 MB Application: After Access::getAssetRules (id:249 name:com_k2)

Time: 36.88 ms / 108.52 ms Memory: 1.031 MB / 3.45 MB Application: beforeRenderModule mod_sigplus (Inner slideshow)

Time: 22.58 ms / 131.10 ms Memory: 0.246 MB / 3.70 MB Application: afterRenderModule mod_sigplus (Inner slideshow)

Time: 1.29 ms / 132.39 ms Memory: -0.002 MB / 3.69 MB Application: beforeRenderModule mod_k2_tools (Archive)

Time: 32.66 ms / 165.05 ms Memory: 0.225 MB / 3.92 MB Application: afterRenderModule mod_k2_tools (Archive)

Time: 0.06 ms / 165.10 ms Memory: -0.013 MB / 3.91 MB Application: beforeRenderModule mod_k2_content (Most popular)

Time: 6.48 ms / 171.58 ms Memory: 0.260 MB / 4.17 MB Application: afterRenderModule mod_k2_content (Most popular)

Time: 0.07 ms / 171.65 ms Memory: -0.110 MB / 4.06 MB Application: beforeRenderModule mod_k2_tools (Tagcloud)

Time: 25.30 ms / 196.95 ms Memory: 0.105 MB / 4.16 MB Application: afterRenderModule mod_k2_tools (Tagcloud)

Time: 0.23 ms / 197.17 ms Memory: -0.013 MB / 4.15 MB Application: afterRenderComponent com_k2

Time: 0.64 ms / 197.81 ms Memory: 0.006 MB / 4.15 MB Application: afterDispatch

Time: 0.96 ms / 198.77 ms Memory: 0.031 MB / 4.19 MB Application: beforeRenderModule mod_menu (Main Menu)

Time: 1.40 ms / 200.17 ms Memory: 0.057 MB / 4.24 MB Application: afterRenderModule mod_menu (Main Menu)

Time: 2.99 ms / 203.16 ms Memory: 0.099 MB / 4.34 MB Application: afterRender

Database queries total: 112.06 ms

Memory Usage

Database Queries

55 Queries Logged 112.06 ms

2 duplicate found!

2 duplicates: #36 #37

Query Time: 4.72 ms Query memory: 0.023 MB Memory before query: 1.245 MB Rows returned: 0

SELECT `data`

  FROM `eygea_session`

  WHERE `session_id` = X'6462343866616430353031363032633066656538343331326236656331383536'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	eygea_session	const	PRIMARY	PRIMARY	194	const	1

Profile

Status	Duration
Starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.01 ms
Executing	0.44 ms
End of update loop	0.02 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	2.54 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Same as call in the line below.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:661
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.02 ms After last query: 0.52 ms Query memory: 0.020 MB Memory before query: 1.261 MB Rows returned: 0

SELECT `session_id`

  FROM `eygea_session`

  WHERE `session_id` = X'6462343866616430353031363032633066656538343331326236656331383536' 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	eygea_session	const	PRIMARY	PRIMARY	194	const	1	Using index

Profile

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.01 ms
Executing	0.30 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.96 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.05 ms After last query: 0.24 ms Query memory: 0.004 MB Memory before query: 1.267 MB

INSERT INTO `eygea_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'6462343866616430353031363032633066656538343331326236656331383536', 1, 1731965251, 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `eygea_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6462343866616430353031363032633066656538343331326236656331383536', 1, 1731965251, 0, '', 0)

Profile

Status	Duration
Starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init for update	0.02 ms
Update	0.09 ms
Waiting for query cache lock	0.00 ms
Update	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.82 ms
closing tables	0.03 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.87 ms After last query: 1.36 ms Query memory: 0.040 MB Memory before query: 1.364 MB Rows returned: 44

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `eygea_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	eygea_extensions	ref	extension	extension	82	const	45	Using index condition; Using where

Profile

Status	Duration
Starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	1.02 ms
End of update loop	0.11 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.90 ms After last query: 1.16 ms Query memory: 0.021 MB Memory before query: 1.406 MB Rows returned: 4

SELECT id, rules

  FROM `eygea_viewlevels`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	eygea_viewlevels	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	4

Profile

Status	Duration
Starting	0.14 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.11 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.85 ms
End of update loop	0.05 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 3.19 ms After last query: 0.22 ms Query memory: 0.021 MB Memory before query: 1.417 MB Rows returned: 2

SELECT b.id

  FROM eygea_usergroups AS a

  LEFT JOIN eygea_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 9

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	2	Using where; Using index

Profile

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.61 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.23 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.69 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.26 ms After last query: 0.39 ms Query memory: 0.030 MB Memory before query: 1.440 MB Rows returned: 88

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM eygea_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1,5)

  ORDER BY ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	eygea_extensions	ALL	extension	NO INDEX KEY COULD BE USED	NULL	NULL	349	Using where; Using filesort

Profile

Status	Duration
Starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.36 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:356
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.12 ms After last query: 12.83 ms Query memory: 0.052 MB Memory before query: 1.898 MB Rows returned: 28

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM eygea_menu AS m

  LEFT JOIN eygea_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	40	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	swp_db.m.component_id	1	Using where

Profile

Status	Duration
Starting	0.13 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.32 ms
End of update loop	0.02 ms
Query end	0.00 ms
Commit	0.02 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1141
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.20 ms After last query: 2.60 ms Query memory: 0.025 MB Memory before query: 2.161 MB Rows returned: 1

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `eygea_extensions`

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	eygea_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using index condition

Profile

Status	Duration
Starting	0.17 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.10 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.06 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.55 ms
Reset for next command	0.04 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/k2/k2.php:374
8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.81 ms After last query: 0.25 ms Query memory: 0.006 MB Memory before query: 2.153 MB

UPDATE `eygea_extensions`

  SET `params` = '{\"mediaversion\":\"e847631780eb8af7fe3f48cb686f5bde\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explain

EXPLAIN not possible on query: UPDATE `eygea_extensions` SET `params` = '{\"mediaversion\":\"e847631780eb8af7fe3f48cb686f5bde\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profile

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.00 ms
init for update	0.09 ms
Updating	0.05 ms
End of update loop	0.00 ms
Waiting for query cache lock	0.00 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	1.27 ms
closing tables	0.02 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/k2/k2.php:374
8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.59 ms After last query: 1.24 ms Query memory: 0.022 MB Memory before query: 2.280 MB Rows returned: 1

SELECT *

  FROM eygea_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	eygea_languages	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using filesort

Profile

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.09 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.05 ms
Starting cleanup	0.02 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
12	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
11	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/components/com_k2/helpers/utilities.php:248
10	K2HelperUtilities::getParams()	JROOT/administrator/components/com_k2/helpers/html.php:244
9	K2HelperHTML::loadHeadIncludes()	JROOT/plugins/system/k2/k2.php:390
8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.62 ms After last query: 1.17 ms Query memory: 0.025 MB Memory before query: 2.303 MB Rows returned: 3

SELECT id, home, template, s.params

  FROM eygea_template_styles as s

  LEFT JOIN eygea_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ref	idx_template,idx_client_id,idx_client_id_home	idx_client_id	1	const	3
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	swp_db.s.template,const	1	Using index condition; Using where

Profile

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.10 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.08 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
19	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/HTML/HTMLHelper.php:365
18	Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles()	JROOT/libraries/src/HTML/HTMLHelper.php:712
17	Joomla\CMS\HTML\HTMLHelper::script()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/cms/html/jquery.php:52
13	JHtmlJquery::framework()	Same as call in the line below.
12	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
11	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
10	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/administrator/components/com_k2/helpers/html.php:268
9	K2HelperHTML::loadHeadIncludes()	JROOT/plugins/system/k2/k2.php:390
8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.90 ms After last query: 1.45 ms Query memory: 0.026 MB Memory before query: 2.358 MB Rows returned: 44

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `eygea_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_extplorer','com_fields','com_finder','com_flexicontact','com_installer','com_joomlaupdate','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_profiles','com_redirect','com_search','com_slideshowck','com_swp','com_tags','com_templates','com_users','com_venues','com_watchfulli','com_weblinks','com_wrapper')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	eygea_assets	range	idx_asset_name	idx_asset_name	202	NULL	45	Using index condition

Profile

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.01 ms
Statistics	0.09 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.26 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
11	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
10	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
9	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
8	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
7	Joomla\CMS\User\User->authorise()	JROOT/components/com_k2/k2.php:16
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.23 ms After last query: 4.05 ms Query memory: 0.022 MB Memory before query: 2.854 MB Rows returned: 1

SELECT id, name 
  FROM eygea_k2_tags 
  WHERE name = 'wedding jewellery'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	eygea_k2_tags	ALL	name	NO INDEX KEY COULD BE USED	NULL	NULL	327	Using where

Profile

Status	Duration
Starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.09 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.18 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/components/com_k2/views/itemlist/view.html.php:280
11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.33 ms After last query: 0.88 ms Query memory: 0.022 MB Memory before query: 2.868 MB Rows returned: 1

SELECT id 
  FROM eygea_k2_tags 
  WHERE name='wedding jewellery' 
  LIMIT 0, 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	eygea_k2_tags	ALL	name	NO INDEX KEY COULD BE USED	NULL	NULL	327	Using where

Profile

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.05 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/itemlist.php:222
12	K2ModelItemlist->getData()	JROOT/components/com_k2/views/itemlist/view.html.php:564
11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.22 ms After last query: 0.14 ms Query memory: 0.039 MB Memory before query: 2.875 MB Rows returned: 2

/* Frontend / K2 / Items */ SELECT SQL_CALC_FOUND_ROWS i.*, c.name AS categoryname, c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams 
  FROM eygea_k2_items AS i 
  INNER JOIN eygea_k2_categories AS c 
  ON c.id = i.catid 
  WHERE i.published = 1 
  AND i.access IN(1,5) 
  AND i.trash = 0 
  AND c.published = 1 
  AND c.access IN(1,5) 
  AND c.trash = 0 
  AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2024-11-18 21:27:31') 
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-11-18 21:27:31') 
  AND i.id IN(SELECT itemID 
  FROM eygea_k2_tags_xref 
  WHERE tagID=133) 
  GROUP BY i.id 
  ORDER BY i.id DESC 
  LIMIT 0, 5

Explain

EXPLAIN not possible on query: /* Frontend / K2 / Items */ SELECT SQL_CALC_FOUND_ROWS i.*, c.name AS categoryname, c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams FROM eygea_k2_items AS i INNER JOIN eygea_k2_categories AS c ON c.id = i.catid WHERE i.published = 1 AND i.access IN(1,5) AND i.trash = 0 AND c.published = 1 AND c.access IN(1,5) AND c.trash = 0 AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2024-11-18 21:27:31') AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-11-18 21:27:31') AND i.id IN(SELECT itemID FROM eygea_k2_tags_xref WHERE tagID=133) GROUP BY i.id ORDER BY i.id DESC LIMIT 0, 5

Profile

Status	Duration
Starting	0.12 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.15 ms
init	0.08 ms
Optimizing	0.12 ms
Statistics	0.12 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.06 ms
Creating tmp table	0.04 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.42 ms
Creating sort index	0.47 ms
Removing tmp table	0.30 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Removing tmp table	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.02 ms
Starting cleanup	0.00 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/itemlist.php:348
12	K2ModelItemlist->getData()	JROOT/components/com_k2/views/itemlist/view.html.php:564
11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.22 ms After last query: 0.19 ms Query memory: 0.023 MB Memory before query: 2.906 MB Rows returned: 1

SELECT FOUND_ROWS();

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	No tables used

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
After opening tables	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Executing	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/itemlist.php:361
12	K2ModelItemlist->getData()	JROOT/components/com_k2/views/itemlist/view.html.php:564
11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.18 ms After last query: 0.83 ms Query memory: 0.027 MB Memory before query: 2.923 MB Rows returned: 14

SHOW FULL COLUMNS 
  FROM `eygea_k2_categories`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `eygea_k2_categories`

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.00 ms
closing tables	0.00 ms
Opening tables	0.27 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.02 ms
Executing	0.00 ms
Filling schema table	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
checking permissions	0.08 ms
closing tables	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.11 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.17 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.12 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
15	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
14	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_k2/tables/k2category.php:34
13	TableK2Category->__construct()	JROOT/libraries/src/Table/Table.php:328
12	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_k2/views/itemlist/view.html.php:689
11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.89 ms After last query: 0.45 ms Query memory: 0.024 MB Memory before query: 2.964 MB Rows returned: 1

SELECT * 
  FROM eygea_k2_categories 
  WHERE id = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	eygea_k2_categories	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1

Profile

Status	Duration
Starting	0.06 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.01 ms
Statistics	1.26 ms
Preparing	0.02 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.26 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
17	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_k2/tables/k2category.php:61
16	TableK2Category->load()	JROOT/components/com_k2/models/item.php:65
15	K2ModelItem->prepareItem()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:691
11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.49 ms After last query: 1.04 ms Query memory: 0.030 MB Memory before query: 3.103 MB Rows returned: 17

SHOW FULL COLUMNS 
  FROM `eygea_users`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `eygea_users`

Profile

Status	Duration
Starting	0.23 ms
checking permissions	0.01 ms
closing tables	0.00 ms
Opening tables	0.28 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.00 ms
Filling schema table	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
checking permissions	0.08 ms
closing tables	0.01 ms
Executing	0.00 ms
Sending data	0.04 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.24 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
26	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
25	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
24	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
23	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:41
22	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:328
21	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/User/User.php:603
20	Joomla\CMS\User\User::getTable()	JROOT/libraries/src/User/User.php:877
19	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
18	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
17	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
16	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/models/item.php:201
15	K2ModelItem->prepareItem()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:691
11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 4.73 ms After last query: 0.27 ms Query memory: 0.026 MB Memory before query: 3.135 MB Rows returned: 1

SELECT *

  FROM `eygea_users`

  WHERE `id` = 211

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	eygea_users	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.10 ms
checking permissions	0.67 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.33 ms
Optimizing	3.11 ms
Statistics	0.07 ms
Preparing	0.00 ms
Unlocking tables	0.04 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
21	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:87
20	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
19	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
18	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
17	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
16	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/models/item.php:201
15	K2ModelItem->prepareItem()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:691
11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.59 ms After last query: 0.54 ms Query memory: 0.026 MB Memory before query: 3.151 MB Rows returned: 2

SELECT `g`.`id`,`g`.`title`

  FROM `eygea_usergroups` AS g

  INNER JOIN `eygea_user_usergroup_map` AS m 
  ON m.group_id = g.id

  WHERE `m`.`user_id` = 211

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY	PRIMARY	4	const	2	Using index
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	swp_db.m.group_id	1

Profile

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.11 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
21	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:112
20	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
19	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
18	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
17	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
16	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/models/item.php:201
15	K2ModelItem->prepareItem()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:691
11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.14 ms After last query: 0.72 ms Query memory: 0.025 MB Memory before query: 3.160 MB Rows returned: 1

SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM eygea_k2_users 
  WHERE userID=211

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	eygea_k2_users	ref	userID	userID	4	const	1

Profile

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.69 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1674
17	K2ModelItem->getUserProfile()	JROOT/components/com_k2/helpers/utilities.php:45
16	K2HelperUtilities::getAvatar()	JROOT/components/com_k2/models/item.php:204
15	K2ModelItem->prepareItem()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:691
11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.71 ms After last query: 0.20 ms Query memory: 0.024 MB Memory before query: 3.169 MB Rows returned: 1

SELECT COUNT(*) 
  FROM eygea_k2_comments 
  WHERE itemID=44 
  AND published=1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.12 ms
Optimizing	0.04 ms
Statistics	0.02 ms
Preparing	0.00 ms
Executing	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1461
16	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:218
15	K2ModelItem->prepareItem()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:691
11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.26 ms After last query: 1.33 ms Query memory: 0.025 MB Memory before query: 3.198 MB Rows returned: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM eygea_fields AS a

  LEFT JOIN `eygea_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN eygea_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN eygea_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN eygea_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN eygea_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `eygea_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_k2.itemlist' 
  AND (fc.category_id IS NULL OR fc.category_id IN (1,0)) 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; Using filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	swp_db.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	swp_db.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	swp_db.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	swp_db.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	swp_db.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	swp_db.a.id	1	Using where; Using index; Distinct

Profile

Status	Duration
Starting	0.13 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.03 ms
Statistics	0.10 ms
Preparing	0.03 ms
Creating tmp table	0.04 ms
Sorting result	0.03 ms
Executing	0.00 ms
Sending data	0.37 ms
Creating sort index	0.04 ms
Removing tmp table	0.07 ms
Creating sort index	0.03 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
19	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
18	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
17	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
16	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
15	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
13	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:660
12	K2ModelItem->execPlugins()	JROOT/components/com_k2/views/itemlist/view.html.php:700
11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.66 ms After last query: 1.68 ms Query memory: 0.024 MB Memory before query: 3.300 MB Rows returned: 1

SELECT COUNT(*) 
  FROM eygea_k2_comments 
  WHERE itemID=35 
  AND published=1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
Starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1461
16	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:218
15	K2ModelItem->prepareItem()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:691
11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.67 ms After last query: 1.02 ms Query memory: 0.022 MB Memory before query: 3.272 MB Rows returned: 1

SELECT id 
  FROM eygea_k2_categories 
  WHERE published=1 
  AND trash=0 
  AND access IN(1,1,5)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	eygea_k2_categories	system	category,published,access,trash	NO INDEX KEY COULD BE USED	NULL	NULL	1

Profile

Status	Duration
Starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
13	JDatabaseDriver->loadColumn()	JROOT/components/com_k2/helpers/permissions.php:225
12	K2HelperPermissions::canAddItem()	JROOT/components/com_k2/views/itemlist/view.html.php:748
11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.52 ms After last query: 1.83 ms Query memory: 0.030 MB Memory before query: 3.415 MB Rows returned: 8

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM eygea_modules AS m

  LEFT JOIN eygea_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN eygea_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-11-18 21:27:31') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-11-18 21:27:31') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 202 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	22	Using index condition; Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	swp_db.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	swp_db.m.module,const	1	Using index condition; Using where

Profile

Status	Duration
Starting	0.35 ms
checking permissions	0.01 ms
Opening tables	0.09 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.04 ms
Statistics	0.09 ms
Preparing	0.04 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.41 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
29	JDatabaseDriver->loadObjectList()	Same as call in the line below.
28	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
27	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
26	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
25	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
24	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/plugins/content/loadmodule/loadmodule.php:169
23	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
22	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
21	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
20	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
19	JHtmlContent::prepare()	Same as call in the line below.
18	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
17	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
16	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/swp/html/com_k2/default/tag.php:13
15	include JROOT/templates/swp/html/com_k2/default/tag.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_k2/views/view.php:35
12	K2View->display()	JROOT/components/com_k2/views/itemlist/view.html.php:1460
11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.16 ms After last query: 1.61 ms Query memory: 0.029 MB Memory before query: 3.571 MB Rows returned: 1

SELECT `folderid`, `foldertime`, `entitytag` 
  FROM `eygea_sigplus_folder` 
  WHERE `folderurl` = '/home/swp/public_html/images/slideshow/
  inner/'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	eygea_sigplus_folder	const	folderurl	folderurl	769	const	1

Profile

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.00 ms
Unlocking tables	0.02 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1773
28	JDatabaseDriver->loadRow()	JROOT/plugins/content/sigplus/core/core.php:3081
27	SigPlusNovoCore->getGalleryHTML()	JROOT/modules/mod_sigplus/mod_sigplus.php:78
26	include JROOT/modules/mod_sigplus/mod_sigplus.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
25	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
24	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:175
23	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
22	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
21	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
20	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
19	JHtmlContent::prepare()	Same as call in the line below.
18	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
17	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
16	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/swp/html/com_k2/default/tag.php:13
15	include JROOT/templates/swp/html/com_k2/default/tag.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_k2/views/view.php:35
12	K2View->display()	JROOT/components/com_k2/views/itemlist/view.html.php:1460
11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.59 ms After last query: 0.11 ms Query memory: 0.013 MB Memory before query: 3.584 MB

START TRANSACTION

Explain

EXPLAIN not possible on query: START TRANSACTION

Profile

Status	Duration
Starting	0.03 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.19 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver/mysqli.php:837
29	JDatabaseDriverMysqli->transactionStart()	JROOT/plugins/content/sigplus/core/core.php:1063
28	SigPlusNovoGalleryBase->update()	JROOT/plugins/content/sigplus/core/core.php:3089
27	SigPlusNovoCore->getGalleryHTML()	JROOT/modules/mod_sigplus/mod_sigplus.php:78
26	include JROOT/modules/mod_sigplus/mod_sigplus.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
25	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
24	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:175
23	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
22	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
21	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
20	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
19	JHtmlContent::prepare()	Same as call in the line below.
18	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
17	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
16	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/swp/html/com_k2/default/tag.php:13
15	include JROOT/templates/swp/html/com_k2/default/tag.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_k2/views/view.php:35
12	K2View->display()	JROOT/components/com_k2/views/itemlist/view.html.php:1460
11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.99 ms After last query: 0.39 ms Query memory: 0.032 MB Memory before query: 3.600 MB Rows returned: 1

SELECT viewid

  FROM eygea_sigplus_view

  WHERE folderid = 8 
  AND hash = 0x0e3b2b457d620aa2e9e14ddd49cbc307

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	eygea_sigplus_view	const	hash,eygea_FK_sigplus_view_folder	hash	16	const	1

Profile

Status	Duration
Starting	0.06 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.53 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
33	JDatabaseDriver->loadResult()	JROOT/plugins/content/sigplus/core/core.php:1211
32	SigPlusNovoGalleryBase->getView()	JROOT/plugins/content/sigplus/core/core.php:1216
31	SigPlusNovoGalleryBase->insertView()	JROOT/plugins/content/sigplus/core/core.php:1891
30	SigPlusNovoLocalGallery->populateFolderViews()	JROOT/plugins/content/sigplus/core/core.php:1945
29	SigPlusNovoLocalGallery->populate()	JROOT/plugins/content/sigplus/core/core.php:1065
28	SigPlusNovoGalleryBase->update()	JROOT/plugins/content/sigplus/core/core.php:3089
27	SigPlusNovoCore->getGalleryHTML()	JROOT/modules/mod_sigplus/mod_sigplus.php:78
26	include JROOT/modules/mod_sigplus/mod_sigplus.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
25	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
24	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:175
23	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
22	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
21	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
20	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
19	JHtmlContent::prepare()	Same as call in the line below.
18	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
17	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
16	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/swp/html/com_k2/default/tag.php:13
15	include JROOT/templates/swp/html/com_k2/default/tag.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_k2/views/view.php:35
12	K2View->display()	JROOT/components/com_k2/views/itemlist/view.html.php:1460
11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.57 ms After last query: 0.18 ms Query memory: 0.032 MB Memory before query: 3.615 MB Rows returned: 0

SELECT
i.`fileurl`,
i.`imageid`

  FROM `eygea_sigplus_image` AS i

  INNER JOIN `eygea_sigplus_folder` AS f

  ON i.`folderid` = f.`folderid`

  INNER JOIN `eygea_sigplus_hierarchy` AS h

  ON f.`folderid` = h.`descendantid`

  WHERE h.`ancestorid` = 8 
  AND NOT EXISTS (SELECT * 
  FROM `eygea_sigplus_imageview` AS v 
  WHERE i.`imageid` = v.`imageid` 
  AND v.`viewid` = 6) 
  AND depthnum <= 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	h	ref	PRIMARY,eygea_FK_sigplus_hierarchy_descendant,eygea_IX_sigplus_hierarchy_depthnum	PRIMARY	4	const	1	Using where
1	PRIMARY	f	eq_ref	PRIMARY	PRIMARY	4	swp_db.h.descendantid	1	Using index
1	PRIMARY	i	ref	eygea_FK_sigplus_image_folder	eygea_FK_sigplus_image_folder	5	swp_db.h.descendantid	1	Using where
2	MATERIALIZED	v	ref	PRIMARY,eygea_FK_sigplus_imageview_view	eygea_FK_sigplus_imageview_view	4	const	3	Using index

Profile

Status	Duration
Starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.13 ms
Preparing	0.02 ms
Optimizing	0.01 ms
Statistics	0.06 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.05 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Removing tmp table	0.01 ms
Freeing items	0.01 ms
Removing tmp table	0.00 ms
Freeing items	0.00 ms
Updating status	0.37 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1811
32	JDatabaseDriver->loadRowList()	JROOT/plugins/content/sigplus/core/core.php:1807
31	SigPlusNovoLocalBase->getMissingImageViews()	JROOT/plugins/content/sigplus/core/core.php:1894
30	SigPlusNovoLocalGallery->populateFolderViews()	JROOT/plugins/content/sigplus/core/core.php:1945
29	SigPlusNovoLocalGallery->populate()	JROOT/plugins/content/sigplus/core/core.php:1065
28	SigPlusNovoGalleryBase->update()	JROOT/plugins/content/sigplus/core/core.php:3089
27	SigPlusNovoCore->getGalleryHTML()	JROOT/modules/mod_sigplus/mod_sigplus.php:78
26	include JROOT/modules/mod_sigplus/mod_sigplus.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
25	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
24	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:175
23	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
22	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
21	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
20	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
19	JHtmlContent::prepare()	Same as call in the line below.
18	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
17	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
16	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/swp/html/com_k2/default/tag.php:13
15	include JROOT/templates/swp/html/com_k2/default/tag.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_k2/views/view.php:35
12	K2View->display()	JROOT/components/com_k2/views/itemlist/view.html.php:1460
11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.02 ms After last query: 0.10 ms Query memory: 0.015 MB Memory before query: 3.637 MB

COMMIT

Explain

EXPLAIN not possible on query: COMMIT

Profile

Status	Duration
Starting	0.66 ms
Query end	0.01 ms
Commit	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver/mysqli.php:777
29	JDatabaseDriverMysqli->transactionCommit()	JROOT/plugins/content/sigplus/core/core.php:1071
28	SigPlusNovoGalleryBase->update()	JROOT/plugins/content/sigplus/core/core.php:3089
27	SigPlusNovoCore->getGalleryHTML()	JROOT/modules/mod_sigplus/mod_sigplus.php:78
26	include JROOT/modules/mod_sigplus/mod_sigplus.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
25	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
24	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:175
23	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
22	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
21	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
20	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
19	JHtmlContent::prepare()	Same as call in the line below.
18	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
17	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
16	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/swp/html/com_k2/default/tag.php:13
15	include JROOT/templates/swp/html/com_k2/default/tag.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_k2/views/view.php:35
12	K2View->display()	JROOT/components/com_k2/views/itemlist/view.html.php:1460
11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.83 ms After last query: 0.15 ms Query memory: 0.029 MB Memory before query: 3.652 MB Rows returned: 1

SELECT
`langid`

  FROM `eygea_sigplus_language`

  WHERE
`lang` = 'en'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	eygea_sigplus_language	const	lang	lang	2	const	1	Using index

Profile

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.00 ms
Unlocking tables	0.47 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.58 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
29	JDatabaseDriver->loadResult()	JROOT/plugins/content/sigplus/core/core.php:317
28	SigPlusNovoDatabase::getLanguageId()	JROOT/plugins/content/sigplus/core/core.php:3167
27	SigPlusNovoCore->getGalleryHTML()	JROOT/modules/mod_sigplus/mod_sigplus.php:78
26	include JROOT/modules/mod_sigplus/mod_sigplus.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
25	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
24	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:175
23	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
22	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
21	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
20	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
19	JHtmlContent::prepare()	Same as call in the line below.
18	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
17	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
16	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/swp/html/com_k2/default/tag.php:13
15	include JROOT/templates/swp/html/com_k2/default/tag.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_k2/views/view.php:35
12	K2View->display()	JROOT/components/com_k2/views/itemlist/view.html.php:1460
11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.25 ms After last query: 0.16 ms Query memory: 0.029 MB Memory before query: 3.666 MB Rows returned: 1

SELECT
`countryid`

  FROM `eygea_sigplus_country`

  WHERE
`country` = 'GB'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	eygea_sigplus_country	const	country	country	2	const	1	Using index

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
29	JDatabaseDriver->loadResult()	JROOT/plugins/content/sigplus/core/core.php:332
28	SigPlusNovoDatabase::getCountryId()	JROOT/plugins/content/sigplus/core/core.php:3168
27	SigPlusNovoCore->getGalleryHTML()	JROOT/modules/mod_sigplus/mod_sigplus.php:78
26	include JROOT/modules/mod_sigplus/mod_sigplus.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
25	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
24	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:175
23	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
22	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
21	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
20	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
19	JHtmlContent::prepare()	Same as call in the line below.
18	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
17	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
16	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/swp/html/com_k2/default/tag.php:13
15	include JROOT/templates/swp/html/com_k2/default/tag.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_k2/views/view.php:35
12	K2View->display()	JROOT/components/com_k2/views/itemlist/view.html.php:1460
11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 3.89 ms After last query: 0.20 ms Query memory: 0.029 MB Memory before query: 3.684 MB Rows returned: 3

Duplicate queries: #37

SELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT  md.`textvalue`

  FROM `eygea_sigplus_property` AS mp

  INNER JOIN `eygea_sigplus_data` AS md

  ON mp.`propertyid` = md.`propertyid`

  WHERE mp.`propertyname` = 'Headline' 
  AND md.`imageid` = i.`imageid`

  LIMIT 1
),
(
SELECT  md.`textvalue`

  FROM `eygea_sigplus_property` AS mp

  INNER JOIN `eygea_sigplus_data` AS md

  ON mp.`propertyid` = md.`propertyid`

  WHERE mp.`propertyname` = 'Object Name' 
  AND md.`imageid` = i.`imageid`

  LIMIT 1
),
(
SELECT  p.`title`

  FROM `eygea_sigplus_foldercaption` AS p

  WHERE
p.`langid` = 38 
  AND 
p.`countryid` = 67 
  AND 
i.`filename` LIKE p.`pattern` 
  AND 
i.`folderid` = p.`folderid`

  ORDER BY p.`priority` 
  LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT  md.`textvalue`

  FROM `eygea_sigplus_property` AS mp

  INNER JOIN `eygea_sigplus_data` AS md

  ON mp.`propertyid` = md.`propertyid`

  WHERE mp.`propertyname` = 'Caption-Abstract' 
  AND md.`imageid` = i.`imageid`

  LIMIT 1
),
(
SELECT  p.`summary`

  FROM `eygea_sigplus_foldercaption` AS p

  WHERE
p.`langid` = 38 
  AND 
p.`countryid` = 67 
  AND 
i.`filename` LIKE p.`pattern` 
  AND 
i.`folderid` = p.`folderid`

  ORDER BY p.`priority` 
  LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`

  FROM `eygea_sigplus_image` AS i

  INNER JOIN `eygea_sigplus_folder` AS f

  ON i.`folderid` = f.`folderid`

  INNER JOIN `eygea_sigplus_hierarchy` AS h

  ON f.`folderid` = h.`descendantid`

  INNER JOIN `eygea_sigplus_folder` AS a

  ON a.`folderid` = h.`ancestorid`

  INNER JOIN `eygea_sigplus_imageview` AS v

  ON i.`imageid` = v.`imageid`

  LEFT JOIN `eygea_sigplus_caption` AS c

  ON
c.`imageid` = i.`imageid` 
  AND 
c.`langid` = 38 
  AND 
c.`countryid` = 67

  WHERE
a.`folderurl` = '/home/swp/public_html/images/slideshow/
  inner/' 
  AND 
`viewid` = 6

 
  AND `depthnum` <= 0


  ORDER BY `depthnum` ASC, -`ordnum` DESC, `filename` ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	const	PRIMARY,folderurl	folderurl	769	const	1	Using index; Using temporary; Using filesort
1	PRIMARY	h	ref	PRIMARY,eygea_FK_sigplus_hierarchy_descendant,eygea_IX_sigplus_hierarchy_depthnum	PRIMARY	4	const	1	Using where
1	PRIMARY	f	eq_ref	PRIMARY	PRIMARY	4	swp_db.h.descendantid	1	Using index
1	PRIMARY	i	ref	PRIMARY,eygea_FK_sigplus_image_folder	eygea_FK_sigplus_image_folder	5	swp_db.h.descendantid	1
1	PRIMARY	v	eq_ref	PRIMARY,eygea_FK_sigplus_imageview_view	PRIMARY	8	swp_db.i.imageid,const	1
1	PRIMARY	c	eq_ref	PRIMARY,eygea_FK_sigplus_caption_language,eygea_FK_sigplus_caption_country	PRIMARY	8	swp_db.i.imageid,const,const	1
6	DEPENDENT SUBQUERY	p	index	PRIMARY,eygea_FK_sigplus_foldercaption_language,eygea_FK_sigplus_foldercaption_country	eygea_IX_sigplus_foldercaption_priority	2	NULL	1	Using where
5	DEPENDENT SUBQUERY	mp	const	PRIMARY,propertyname	propertyname	257	const	1	Using index
5	DEPENDENT SUBQUERY	md	eq_ref	PRIMARY,eygea_FK_sigplus_data_property	PRIMARY	8	swp_db.i.imageid,const	1
4	DEPENDENT SUBQUERY	p	index	PRIMARY,eygea_FK_sigplus_foldercaption_language,eygea_FK_sigplus_foldercaption_country	eygea_IX_sigplus_foldercaption_priority	2	NULL	1	Using where
3	DEPENDENT SUBQUERY	mp	const	PRIMARY,propertyname	propertyname	257	const	1	Using index
3	DEPENDENT SUBQUERY	md	eq_ref	PRIMARY,eygea_FK_sigplus_data_property	PRIMARY	8	swp_db.i.imageid,const	1
2	DEPENDENT SUBQUERY	mp	const	PRIMARY,propertyname	propertyname	257	const	1	Using index
2	DEPENDENT SUBQUERY	md	eq_ref	PRIMARY,eygea_FK_sigplus_data_property	PRIMARY	8	swp_db.i.imageid,const	1

Profile

Status	Duration
Starting	0.18 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.93 ms
Optimizing	0.05 ms
Statistics	0.19 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.03 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Sorting result	0.00 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Creating tmp table	0.04 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.33 ms
Removing tmp table	0.01 ms
Sending data	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Removing tmp table	0.00 ms
Sending data	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Removing tmp table	0.00 ms
Sending data	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Removing tmp table	0.00 ms
Sending data	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Removing tmp table	0.00 ms
Sending data	0.00 ms
Executing	0.00 ms
Sending data	0.03 ms
Executing	0.00 ms
Sending data	0.00 ms
Executing	0.00 ms
Sending data	0.00 ms
Executing	0.00 ms
Sending data	0.00 ms
Executing	0.00 ms
Sending data	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Executing	0.00 ms
Sending data	0.00 ms
Executing	0.00 ms
Sending data	0.00 ms
Executing	0.00 ms
Sending data	0.00 ms
Executing	0.00 ms
Sending data	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.03 ms
Removing tmp table	0.32 ms
Creating sort index	0.26 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.06 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
28	JDatabaseDriverMysqli->execute()	JROOT/plugins/content/sigplus/core/core.php:3330
27	SigPlusNovoCore->getGalleryHTML()	JROOT/modules/mod_sigplus/mod_sigplus.php:78
26	include JROOT/modules/mod_sigplus/mod_sigplus.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
25	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
24	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:175
23	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
22	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
21	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
20	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
19	JHtmlContent::prepare()	Same as call in the line below.
18	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
17	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
16	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/swp/html/com_k2/default/tag.php:13
15	include JROOT/templates/swp/html/com_k2/default/tag.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_k2/views/view.php:35
12	K2View->display()	JROOT/components/com_k2/views/itemlist/view.html.php:1460
11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 3.00 ms After last query: 0.17 ms Query memory: 0.030 MB Memory before query: 3.699 MB Rows returned: 3

Duplicate queries: #36

SELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT  md.`textvalue`

  FROM `eygea_sigplus_property` AS mp

  INNER JOIN `eygea_sigplus_data` AS md

  ON mp.`propertyid` = md.`propertyid`

  WHERE mp.`propertyname` = 'Headline' 
  AND md.`imageid` = i.`imageid`

  LIMIT 1
),
(
SELECT  md.`textvalue`

  FROM `eygea_sigplus_property` AS mp

  INNER JOIN `eygea_sigplus_data` AS md

  ON mp.`propertyid` = md.`propertyid`

  WHERE mp.`propertyname` = 'Object Name' 
  AND md.`imageid` = i.`imageid`

  LIMIT 1
),
(
SELECT  p.`title`

  FROM `eygea_sigplus_foldercaption` AS p

  WHERE
p.`langid` = 38 
  AND 
p.`countryid` = 67 
  AND 
i.`filename` LIKE p.`pattern` 
  AND 
i.`folderid` = p.`folderid`

  ORDER BY p.`priority` 
  LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT  md.`textvalue`

  FROM `eygea_sigplus_property` AS mp

  INNER JOIN `eygea_sigplus_data` AS md

  ON mp.`propertyid` = md.`propertyid`

  WHERE mp.`propertyname` = 'Caption-Abstract' 
  AND md.`imageid` = i.`imageid`

  LIMIT 1
),
(
SELECT  p.`summary`

  FROM `eygea_sigplus_foldercaption` AS p

  WHERE
p.`langid` = 38 
  AND 
p.`countryid` = 67 
  AND 
i.`filename` LIKE p.`pattern` 
  AND 
i.`folderid` = p.`folderid`

  ORDER BY p.`priority` 
  LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`

  FROM `eygea_sigplus_image` AS i

  INNER JOIN `eygea_sigplus_folder` AS f

  ON i.`folderid` = f.`folderid`

  INNER JOIN `eygea_sigplus_hierarchy` AS h

  ON f.`folderid` = h.`descendantid`

  INNER JOIN `eygea_sigplus_folder` AS a

  ON a.`folderid` = h.`ancestorid`

  INNER JOIN `eygea_sigplus_imageview` AS v

  ON i.`imageid` = v.`imageid`

  LEFT JOIN `eygea_sigplus_caption` AS c

  ON
c.`imageid` = i.`imageid` 
  AND 
c.`langid` = 38 
  AND 
c.`countryid` = 67

  WHERE
a.`folderurl` = '/home/swp/public_html/images/slideshow/
  inner/' 
  AND 
`viewid` = 6

 
  AND `depthnum` <= 0


  ORDER BY `depthnum` ASC, -`ordnum` DESC, `filename` ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	const	PRIMARY,folderurl	folderurl	769	const	1	Using index; Using temporary; Using filesort
1	PRIMARY	h	ref	PRIMARY,eygea_FK_sigplus_hierarchy_descendant,eygea_IX_sigplus_hierarchy_depthnum	PRIMARY	4	const	1	Using where
1	PRIMARY	f	eq_ref	PRIMARY	PRIMARY	4	swp_db.h.descendantid	1	Using index
1	PRIMARY	i	ref	PRIMARY,eygea_FK_sigplus_image_folder	eygea_FK_sigplus_image_folder	5	swp_db.h.descendantid	1
1	PRIMARY	v	eq_ref	PRIMARY,eygea_FK_sigplus_imageview_view	PRIMARY	8	swp_db.i.imageid,const	1
1	PRIMARY	c	eq_ref	PRIMARY,eygea_FK_sigplus_caption_language,eygea_FK_sigplus_caption_country	PRIMARY	8	swp_db.i.imageid,const,const	1
6	DEPENDENT SUBQUERY	p	index	PRIMARY,eygea_FK_sigplus_foldercaption_language,eygea_FK_sigplus_foldercaption_country	eygea_IX_sigplus_foldercaption_priority	2	NULL	1	Using where
5	DEPENDENT SUBQUERY	mp	const	PRIMARY,propertyname	propertyname	257	const	1	Using index
5	DEPENDENT SUBQUERY	md	eq_ref	PRIMARY,eygea_FK_sigplus_data_property	PRIMARY	8	swp_db.i.imageid,const	1
4	DEPENDENT SUBQUERY	p	index	PRIMARY,eygea_FK_sigplus_foldercaption_language,eygea_FK_sigplus_foldercaption_country	eygea_IX_sigplus_foldercaption_priority	2	NULL	1	Using where
3	DEPENDENT SUBQUERY	mp	const	PRIMARY,propertyname	propertyname	257	const	1	Using index
3	DEPENDENT SUBQUERY	md	eq_ref	PRIMARY,eygea_FK_sigplus_data_property	PRIMARY	8	swp_db.i.imageid,const	1
2	DEPENDENT SUBQUERY	mp	const	PRIMARY,propertyname	propertyname	257	const	1	Using index
2	DEPENDENT SUBQUERY	md	eq_ref	PRIMARY,eygea_FK_sigplus_data_property	PRIMARY	8	swp_db.i.imageid,const	1

Profile

Status	Duration
Starting	0.18 ms
checking permissions	0.07 ms
Opening tables	0.06 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.10 ms
Optimizing	0.03 ms
Statistics	0.14 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.03 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Sorting result	0.00 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.02 ms
Creating tmp table	0.05 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.34 ms
Removing tmp table	0.01 ms
Sending data	0.00 ms
Executing	0.00 ms
Sending data	0.02 ms
Removing tmp table	0.00 ms
Sending data	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Removing tmp table	0.00 ms
Sending data	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Removing tmp table	0.00 ms
Sending data	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Removing tmp table	0.00 ms
Sending data	0.00 ms
Executing	0.00 ms
Sending data	0.04 ms
Executing	0.00 ms
Sending data	0.00 ms
Executing	0.00 ms
Sending data	0.00 ms
Executing	0.00 ms
Sending data	0.00 ms
Executing	0.00 ms
Sending data	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Executing	0.00 ms
Sending data	0.00 ms
Executing	0.00 ms
Sending data	0.00 ms
Executing	0.00 ms
Sending data	0.00 ms
Executing	0.00 ms
Sending data	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.22 ms
Removing tmp table	0.27 ms
Creating sort index	0.43 ms
End of update loop	0.02 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.03 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1811
28	JDatabaseDriver->loadRowList()	JROOT/plugins/content/sigplus/core/core.php:3337
27	SigPlusNovoCore->getGalleryHTML()	JROOT/modules/mod_sigplus/mod_sigplus.php:78
26	include JROOT/modules/mod_sigplus/mod_sigplus.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
25	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
24	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:175
23	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
22	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
21	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
20	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
19	JHtmlContent::prepare()	Same as call in the line below.
18	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
17	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
16	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/swp/html/com_k2/default/tag.php:13
15	include JROOT/templates/swp/html/com_k2/default/tag.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_k2/views/view.php:35
12	K2View->display()	JROOT/components/com_k2/views/itemlist/view.html.php:1460
11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.35 ms After last query: 7.08 ms Query memory: 0.029 MB Memory before query: 3.737 MB Rows returned: 12

SELECT DISTINCT MONTH(created) as m, YEAR(created) as y 
  FROM eygea_k2_items 
  WHERE published=1 
  AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-11-18 21:27:31' ) 
  AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-11-18 21:27:31' ) 
  AND trash=0 
  AND access IN(1,1,5)  
  AND catid=1 
  ORDER BY created DESC 
  LIMIT 0, 12

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	eygea_k2_items	range	catid,idx_item	idx_item	7	NULL	61	Using index condition; Using where; Using temporary; Using filesort

Profile

Status	Duration
Starting	0.20 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.04 ms
Statistics	0.08 ms
Preparing	0.04 ms
Creating tmp table	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.30 ms
Creating sort index	0.03 ms
Removing tmp table	0.02 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
28	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_k2_tools/helper.php:175
27	modK2ToolsHelper::getArchive()	JROOT/modules/mod_k2_tools/mod_k2_tools.php:39
26	include JROOT/modules/mod_k2_tools/mod_k2_tools.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
25	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
24	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:175
23	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
22	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
21	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
20	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
19	JHtmlContent::prepare()	Same as call in the line below.
18	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
17	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
16	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/swp/html/com_k2/default/tag.php:26
15	include JROOT/templates/swp/html/com_k2/default/tag.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_k2/views/view.php:35
12	K2View->display()	JROOT/components/com_k2/views/itemlist/view.html.php:1460
11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 3.17 ms After last query: 0.66 ms Query memory: 0.029 MB Memory before query: 3.758 MB Rows returned: 1

SELECT COUNT(*) 
  FROM eygea_k2_items 
  WHERE MONTH(created)=7 
  AND YEAR(created)=2016 
  AND published=1 
  AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-11-18 21:27:31' ) 
  AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-11-18 21:27:31' ) 
  AND trash=0  
  AND access IN(1,1,5)  
  AND catid=1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	eygea_k2_items	range	catid,idx_item	idx_item	7	NULL	61	Using index condition; Using where

Profile

Status	Duration
Starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.04 ms
Statistics	0.07 ms
Preparing	0.04 ms
Executing	0.00 ms
Sending data	0.25 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	1.61 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
29	JDatabaseDriver->loadResult()	JROOT/modules/mod_k2_tools/helper.php:795
28	modK2ToolsHelper::countArchiveItems()	JROOT/modules/mod_k2_tools/helper.php:193
27	modK2ToolsHelper::getArchive()	JROOT/modules/mod_k2_tools/mod_k2_tools.php:39
26	include JROOT/modules/mod_k2_tools/mod_k2_tools.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
25	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
24	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:175
23	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
22	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
21	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
20	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
19	JHtmlContent::prepare()	Same as call in the line below.
18	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
17	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
16	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/swp/html/com_k2/default/tag.php:26
15	include JROOT/templates/swp/html/com_k2/default/tag.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_k2/views/view.php:35
12	K2View->display()	JROOT/components/com_k2/views/itemlist/view.html.php:1460
11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.80 ms After last query: 0.91 ms Query memory: 0.029 MB Memory before query: 3.774 MB Rows returned: 1

SELECT COUNT(*) 
  FROM eygea_k2_items 
  WHERE MONTH(created)=1 
  AND YEAR(created)=2016 
  AND published=1 
  AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-11-18 21:27:31' ) 
  AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-11-18 21:27:31' ) 
  AND trash=0  
  AND access IN(1,1,5)  
  AND catid=1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	eygea_k2_items	range	catid,idx_item	idx_item	7	NULL	61	Using index condition; Using where

Profile

Status	Duration
Starting	0.12 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.35 ms
Optimizing	0.06 ms
Statistics	0.08 ms
Preparing	0.04 ms
Executing	0.00 ms
Sending data	0.26 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.27 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
29	JDatabaseDriver->loadResult()	JROOT/modules/mod_k2_tools/helper.php:795
28	modK2ToolsHelper::countArchiveItems()	JROOT/modules/mod_k2_tools/helper.php:193
27	modK2ToolsHelper::getArchive()	JROOT/modules/mod_k2_tools/mod_k2_tools.php:39
26	include JROOT/modules/mod_k2_tools/mod_k2_tools.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
25	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
24	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:175
23	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
22	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
21	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
20	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
19	JHtmlContent::prepare()	Same as call in the line below.
18	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
17	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
16	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/swp/html/com_k2/default/tag.php:26
15	include JROOT/templates/swp/html/com_k2/default/tag.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_k2/views/view.php:35
12	K2View->display()	JROOT/components/com_k2/views/itemlist/view.html.php:1460
11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.18 ms After last query: 0.65 ms Query memory: 0.029 MB Memory before query: 3.788 MB Rows returned: 1

SELECT COUNT(*) 
  FROM eygea_k2_items 
  WHERE MONTH(created)=12 
  AND YEAR(created)=2015 
  AND published=1 
  AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-11-18 21:27:31' ) 
  AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-11-18 21:27:31' ) 
  AND trash=0  
  AND access IN(1,1,5)  
  AND catid=1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	eygea_k2_items	range	catid,idx_item	idx_item	7	NULL	61	Using index condition; Using where

Profile

Status	Duration
Starting	0.12 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.04 ms
Statistics	0.07 ms
Preparing	0.04 ms
Executing	0.00 ms
Sending data	0.28 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.07 ms
Freeing items	0.01 ms
Updating status	0.13 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
29	JDatabaseDriver->loadResult()	JROOT/modules/mod_k2_tools/helper.php:795
28	modK2ToolsHelper::countArchiveItems()	JROOT/modules/mod_k2_tools/helper.php:193
27	modK2ToolsHelper::getArchive()	JROOT/modules/mod_k2_tools/mod_k2_tools.php:39
26	include JROOT/modules/mod_k2_tools/mod_k2_tools.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
25	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
24	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:175
23	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
22	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
21	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
20	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
19	JHtmlContent::prepare()	Same as call in the line below.
18	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
17	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
16	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/swp/html/com_k2/default/tag.php:26
15	include JROOT/templates/swp/html/com_k2/default/tag.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_k2/views/view.php:35
12	K2View->display()	JROOT/components/com_k2/views/itemlist/view.html.php:1460
11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.64 ms After last query: 0.35 ms Query memory: 0.029 MB Memory before query: 3.803 MB Rows returned: 1

SELECT COUNT(*) 
  FROM eygea_k2_items 
  WHERE MONTH(created)=11 
  AND YEAR(created)=2015 
  AND published=1 
  AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-11-18 21:27:31' ) 
  AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-11-18 21:27:31' ) 
  AND trash=0  
  AND access IN(1,1,5)  
  AND catid=1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	eygea_k2_items	range	catid,idx_item	idx_item	7	NULL	61	Using index condition; Using where

Profile

Status	Duration
Starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.13 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.04 ms
Statistics	0.07 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.24 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.56 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
29	JDatabaseDriver->loadResult()	JROOT/modules/mod_k2_tools/helper.php:795
28	modK2ToolsHelper::countArchiveItems()	JROOT/modules/mod_k2_tools/helper.php:193
27	modK2ToolsHelper::getArchive()	JROOT/modules/mod_k2_tools/mod_k2_tools.php:39
26	include JROOT/modules/mod_k2_tools/mod_k2_tools.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
25	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
24	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:175
23	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
22	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
21	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
20	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
19	JHtmlContent::prepare()	Same as call in the line below.
18	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
17	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
16	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/swp/html/com_k2/default/tag.php:26
15	include JROOT/templates/swp/html/com_k2/default/tag.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_k2/views/view.php:35
12	K2View->display()	JROOT/components/com_k2/views/itemlist/view.html.php:1460
11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.55 ms After last query: 0.36 ms Query memory: 0.029 MB Memory before query: 3.818 MB Rows returned: 1

SELECT COUNT(*) 
  FROM eygea_k2_items 
  WHERE MONTH(created)=10 
  AND YEAR(created)=2015 
  AND published=1 
  AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-11-18 21:27:31' ) 
  AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-11-18 21:27:31' ) 
  AND trash=0  
  AND access IN(1,1,5)  
  AND catid=1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	eygea_k2_items	range	catid,idx_item	idx_item	7	NULL	61	Using index condition; Using where

Profile

Status	Duration
Starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.04 ms
Statistics	0.07 ms
Preparing	0.04 ms
Executing	0.00 ms
Sending data	0.27 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.19 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
29	JDatabaseDriver->loadResult()	JROOT/modules/mod_k2_tools/helper.php:795
28	modK2ToolsHelper::countArchiveItems()	JROOT/modules/mod_k2_tools/helper.php:193
27	modK2ToolsHelper::getArchive()	JROOT/modules/mod_k2_tools/mod_k2_tools.php:39
26	include JROOT/modules/mod_k2_tools/mod_k2_tools.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
25	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
24	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:175
23	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
22	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
21	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
20	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
19	JHtmlContent::prepare()	Same as call in the line below.
18	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
17	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
16	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/swp/html/com_k2/default/tag.php:26
15	include JROOT/templates/swp/html/com_k2/default/tag.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_k2/views/view.php:35
12	K2View->display()	JROOT/components/com_k2/views/itemlist/view.html.php:1460
11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.89 ms After last query: 0.34 ms Query memory: 0.029 MB Memory before query: 3.833 MB Rows returned: 1

SELECT COUNT(*) 
  FROM eygea_k2_items 
  WHERE MONTH(created)=9 
  AND YEAR(created)=2015 
  AND published=1 
  AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-11-18 21:27:31' ) 
  AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-11-18 21:27:31' ) 
  AND trash=0  
  AND access IN(1,1,5)  
  AND catid=1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	eygea_k2_items	range	catid,idx_item	idx_item	7	NULL	61	Using index condition; Using where

Profile

Status	Duration
Starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.06 ms
Statistics	0.06 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.24 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.89 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
29	JDatabaseDriver->loadResult()	JROOT/modules/mod_k2_tools/helper.php:795
28	modK2ToolsHelper::countArchiveItems()	JROOT/modules/mod_k2_tools/helper.php:193
27	modK2ToolsHelper::getArchive()	JROOT/modules/mod_k2_tools/mod_k2_tools.php:39
26	include JROOT/modules/mod_k2_tools/mod_k2_tools.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
25	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
24	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:175
23	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
22	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
21	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
20	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
19	JHtmlContent::prepare()	Same as call in the line below.
18	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
17	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
16	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/swp/html/com_k2/default/tag.php:26
15	include JROOT/templates/swp/html/com_k2/default/tag.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_k2/views/view.php:35
12	K2View->display()	JROOT/components/com_k2/views/itemlist/view.html.php:1460
11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.15 ms After last query: 0.36 ms Query memory: 0.029 MB Memory before query: 3.847 MB Rows returned: 1

SELECT COUNT(*) 
  FROM eygea_k2_items 
  WHERE MONTH(created)=8 
  AND YEAR(created)=2015 
  AND published=1 
  AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-11-18 21:27:31' ) 
  AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-11-18 21:27:31' ) 
  AND trash=0  
  AND access IN(1,1,5)  
  AND catid=1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	eygea_k2_items	range	catid,idx_item	idx_item	7	NULL	61	Using index condition; Using where

Profile

Status	Duration
Starting	0.12 ms
checking permissions	0.10 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.03 ms
init	0.06 ms
Optimizing	0.04 ms
Statistics	0.08 ms
Preparing	0.04 ms
Executing	0.00 ms
Sending data	0.26 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.30 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
29	JDatabaseDriver->loadResult()	JROOT/modules/mod_k2_tools/helper.php:795
28	modK2ToolsHelper::countArchiveItems()	JROOT/modules/mod_k2_tools/helper.php:193
27	modK2ToolsHelper::getArchive()	JROOT/modules/mod_k2_tools/mod_k2_tools.php:39
26	include JROOT/modules/mod_k2_tools/mod_k2_tools.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
25	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
24	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:175
23	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
22	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
21	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
20	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
19	JHtmlContent::prepare()	Same as call in the line below.
18	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
17	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
16	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/swp/html/com_k2/default/tag.php:26
15	include JROOT/templates/swp/html/com_k2/default/tag.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_k2/views/view.php:35
12	K2View->display()	JROOT/components/com_k2/views/itemlist/view.html.php:1460
11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.77 ms After last query: 0.38 ms Query memory: 0.029 MB Memory before query: 3.862 MB Rows returned: 1

SELECT COUNT(*) 
  FROM eygea_k2_items 
  WHERE MONTH(created)=7 
  AND YEAR(created)=2015 
  AND published=1 
  AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-11-18 21:27:31' ) 
  AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-11-18 21:27:31' ) 
  AND trash=0  
  AND access IN(1,1,5)  
  AND catid=1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	eygea_k2_items	range	catid,idx_item	idx_item	7	NULL	61	Using index condition; Using where

Profile

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.24 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
29	JDatabaseDriver->loadResult()	JROOT/modules/mod_k2_tools/helper.php:795
28	modK2ToolsHelper::countArchiveItems()	JROOT/modules/mod_k2_tools/helper.php:193
27	modK2ToolsHelper::getArchive()	JROOT/modules/mod_k2_tools/mod_k2_tools.php:39
26	include JROOT/modules/mod_k2_tools/mod_k2_tools.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
25	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
24	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:175
23	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
22	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
21	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
20	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
19	JHtmlContent::prepare()	Same as call in the line below.
18	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
17	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
16	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/swp/html/com_k2/default/tag.php:26
15	include JROOT/templates/swp/html/com_k2/default/tag.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_k2/views/view.php:35
12	K2View->display()	JROOT/components/com_k2/views/itemlist/view.html.php:1460
11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.99 ms After last query: 0.27 ms Query memory: 0.029 MB Memory before query: 3.877 MB Rows returned: 1

SELECT COUNT(*) 
  FROM eygea_k2_items 
  WHERE MONTH(created)=6 
  AND YEAR(created)=2015 
  AND published=1 
  AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-11-18 21:27:31' ) 
  AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-11-18 21:27:31' ) 
  AND trash=0  
  AND access IN(1,1,5)  
  AND catid=1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	eygea_k2_items	range	catid,idx_item	idx_item	7	NULL	61	Using index condition; Using where

Profile

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.41 ms
End of update loop	0.02 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.13 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
29	JDatabaseDriver->loadResult()	JROOT/modules/mod_k2_tools/helper.php:795
28	modK2ToolsHelper::countArchiveItems()	JROOT/modules/mod_k2_tools/helper.php:193
27	modK2ToolsHelper::getArchive()	JROOT/modules/mod_k2_tools/mod_k2_tools.php:39
26	include JROOT/modules/mod_k2_tools/mod_k2_tools.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
25	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
24	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:175
23	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
22	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
21	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
20	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
19	JHtmlContent::prepare()	Same as call in the line below.
18	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
17	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
16	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/swp/html/com_k2/default/tag.php:26
15	include JROOT/templates/swp/html/com_k2/default/tag.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_k2/views/view.php:35
12	K2View->display()	JROOT/components/com_k2/views/itemlist/view.html.php:1460
11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.50 ms After last query: 1.91 ms Query memory: 0.029 MB Memory before query: 3.893 MB Rows returned: 1

SELECT COUNT(*) 
  FROM eygea_k2_items 
  WHERE MONTH(created)=5 
  AND YEAR(created)=2015 
  AND published=1 
  AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-11-18 21:27:31' ) 
  AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-11-18 21:27:31' ) 
  AND trash=0  
  AND access IN(1,1,5)  
  AND catid=1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	eygea_k2_items	range	catid,idx_item	idx_item	7	NULL	61	Using index condition; Using where

Profile

Status	Duration
Starting	0.14 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.08 ms
Optimizing	0.04 ms
Statistics	0.07 ms
Preparing	0.04 ms
Executing	0.00 ms
Sending data	0.25 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.05 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.14 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
29	JDatabaseDriver->loadResult()	JROOT/modules/mod_k2_tools/helper.php:795
28	modK2ToolsHelper::countArchiveItems()	JROOT/modules/mod_k2_tools/helper.php:193
27	modK2ToolsHelper::getArchive()	JROOT/modules/mod_k2_tools/mod_k2_tools.php:39
26	include JROOT/modules/mod_k2_tools/mod_k2_tools.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
25	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
24	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:175
23	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
22	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
21	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
20	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
19	JHtmlContent::prepare()	Same as call in the line below.
18	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
17	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
16	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/swp/html/com_k2/default/tag.php:26
15	include JROOT/templates/swp/html/com_k2/default/tag.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_k2/views/view.php:35
12	K2View->display()	JROOT/components/com_k2/views/itemlist/view.html.php:1460
11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.95 ms After last query: 0.40 ms Query memory: 0.029 MB Memory before query: 3.908 MB Rows returned: 1

SELECT COUNT(*) 
  FROM eygea_k2_items 
  WHERE MONTH(created)=4 
  AND YEAR(created)=2015 
  AND published=1 
  AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-11-18 21:27:31' ) 
  AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-11-18 21:27:31' ) 
  AND trash=0  
  AND access IN(1,1,5)  
  AND catid=1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	eygea_k2_items	range	catid,idx_item	idx_item	7	NULL	61	Using index condition; Using where

Profile

Status	Duration
Starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.13 ms
Statistics	0.06 ms
Preparing	0.04 ms
Executing	0.00 ms
Sending data	0.26 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
29	JDatabaseDriver->loadResult()	JROOT/modules/mod_k2_tools/helper.php:795
28	modK2ToolsHelper::countArchiveItems()	JROOT/modules/mod_k2_tools/helper.php:193
27	modK2ToolsHelper::getArchive()	JROOT/modules/mod_k2_tools/mod_k2_tools.php:39
26	include JROOT/modules/mod_k2_tools/mod_k2_tools.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
25	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
24	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:175
23	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
22	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
21	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
20	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
19	JHtmlContent::prepare()	Same as call in the line below.
18	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
17	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
16	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/swp/html/com_k2/default/tag.php:26
15	include JROOT/templates/swp/html/com_k2/default/tag.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_k2/views/view.php:35
12	K2View->display()	JROOT/components/com_k2/views/itemlist/view.html.php:1460
11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.06 ms After last query: 0.32 ms Query memory: 0.029 MB Memory before query: 3.923 MB Rows returned: 1

SELECT COUNT(*) 
  FROM eygea_k2_items 
  WHERE MONTH(created)=3 
  AND YEAR(created)=2015 
  AND published=1 
  AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-11-18 21:27:31' ) 
  AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-11-18 21:27:31' ) 
  AND trash=0  
  AND access IN(1,1,5)  
  AND catid=1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	eygea_k2_items	range	catid,idx_item	idx_item	7	NULL	61	Using index condition; Using where

Profile

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.05 ms
Statistics	0.05 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.26 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.21 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
29	JDatabaseDriver->loadResult()	JROOT/modules/mod_k2_tools/helper.php:795
28	modK2ToolsHelper::countArchiveItems()	JROOT/modules/mod_k2_tools/helper.php:193
27	modK2ToolsHelper::getArchive()	JROOT/modules/mod_k2_tools/mod_k2_tools.php:39
26	include JROOT/modules/mod_k2_tools/mod_k2_tools.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
25	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
24	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:175
23	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
22	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
21	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
20	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
19	JHtmlContent::prepare()	Same as call in the line below.
18	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
17	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
16	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/swp/html/com_k2/default/tag.php:26
15	include JROOT/templates/swp/html/com_k2/default/tag.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_k2/views/view.php:35
12	K2View->display()	JROOT/components/com_k2/views/itemlist/view.html.php:1460
11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.54 ms After last query: 1.21 ms Query memory: 0.029 MB Memory before query: 3.947 MB Rows returned: 0

SELECT id
                        
  FROM eygea_k2_categories
                        
  WHERE parent IN(1)
                            
  AND id NOT IN(1) 
  AND published=1 
  AND trash=0 
  AND access IN(1,1,5)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
Starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
29	JDatabaseDriver->loadColumn()	JROOT/components/com_k2/models/itemlist.php:408
28	K2ModelItemlist->getCategoryTree()	JROOT/modules/mod_k2_content/helper.php:137
27	modK2ContentHelper::getItems()	JROOT/modules/mod_k2_content/mod_k2_content.php:65
26	include JROOT/modules/mod_k2_content/mod_k2_content.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
25	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
24	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:175
23	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
22	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
21	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
20	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
19	JHtmlContent::prepare()	Same as call in the line below.
18	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
17	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
16	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/swp/html/com_k2/default/tag.php:26
15	include JROOT/templates/swp/html/com_k2/default/tag.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_k2/views/view.php:35
12	K2View->display()	JROOT/components/com_k2/views/itemlist/view.html.php:1460
11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 3.06 ms After last query: 0.33 ms Query memory: 0.166 MB Memory before query: 3.962 MB Rows returned: 13

SELECT i.*, c.name AS categoryname, c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams 
  FROM eygea_k2_items AS i RIGHT JOIN eygea_k2_categories AS c 
  ON c.id = i.catid 
  WHERE i.published = 1
                
  AND i.access IN(1,5)
                
  AND i.trash = 0
                
  AND c.published = 1
                
  AND c.access IN(1,5)
                
  AND c.trash = 0
                
  AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2024-11-18 21:27:31')
                
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-11-18 21:27:31') 
  AND i.catid IN (1) 
  ORDER BY i.hits DESC 
  LIMIT 0, 13

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	system	PRIMARY,category,published,access,trash	NO INDEX KEY COULD BE USED	NULL	NULL	1
1	SIMPLE	i	range	catid,idx_item	idx_item	7	NULL	61	Using index condition; Using where; Using filesort

Profile

Status	Duration
Starting	0.14 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.04 ms
Statistics	0.16 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.04 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
Creating sort index	1.29 ms
End of update loop	0.02 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.02 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
28	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_k2_content/helper.php:262
27	modK2ContentHelper::getItems()	JROOT/modules/mod_k2_content/mod_k2_content.php:65
26	include JROOT/modules/mod_k2_content/mod_k2_content.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
25	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
24	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:175
23	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
22	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
21	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
20	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
19	JHtmlContent::prepare()	Same as call in the line below.
18	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
17	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
16	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/swp/html/com_k2/default/tag.php:26
15	include JROOT/templates/swp/html/com_k2/default/tag.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_k2/views/view.php:35
12	K2View->display()	JROOT/components/com_k2/views/itemlist/view.html.php:1460
11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.47 ms After last query: 2.34 ms Query memory: 0.029 MB Memory before query: 4.082 MB Rows returned: 0

SELECT * 
  FROM eygea_k2_categories 
  WHERE parent=1 
  AND published=1 
  AND trash=0  
  AND access IN(1,1,5)  
  ORDER BY ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
Starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.00 ms
Executing	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.83 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
29	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_k2_tools/helper.php:753
28	modK2ToolsHelper::getCategoryChildren()	JROOT/modules/mod_k2_tools/helper.php:254
27	modK2ToolsHelper::tagCloud()	JROOT/modules/mod_k2_tools/mod_k2_tools.php:85
26	include JROOT/modules/mod_k2_tools/mod_k2_tools.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
25	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
24	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:175
23	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
22	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
21	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
20	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
19	JHtmlContent::prepare()	Same as call in the line below.
18	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
17	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
16	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/swp/html/com_k2/default/tag.php:26
15	include JROOT/templates/swp/html/com_k2/default/tag.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_k2/views/view.php:35
12	K2View->display()	JROOT/components/com_k2/views/itemlist/view.html.php:1460
11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.37 ms After last query: 0.20 ms Query memory: 0.030 MB Memory before query: 4.096 MB Rows returned: 46

SELECT i.id 
  FROM eygea_k2_items as i 
  LEFT JOIN eygea_k2_categories c 
  ON c.id = i.catid 
  WHERE i.published=1  
  AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2024-11-18 21:27:31' )  
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-11-18 21:27:31' ) 
  AND i.trash=0  
  AND i.access IN(1,1,5)  
  AND c.published=1  
  AND c.trash=0  
  AND c.access IN(1,1,5)  
  AND i.catid=1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	system	PRIMARY,category,published,access,trash	NO INDEX KEY COULD BE USED	NULL	NULL	1
1	SIMPLE	i	range	catid,idx_item	idx_item	7	NULL	61	Using index condition; Using where

Profile

Status	Duration
Starting	0.21 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.04 ms
Statistics	0.10 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.26 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.13 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
28	JDatabaseDriver->loadColumn()	JROOT/modules/mod_k2_tools/helper.php:275
27	modK2ToolsHelper::tagCloud()	JROOT/modules/mod_k2_tools/mod_k2_tools.php:85
26	include JROOT/modules/mod_k2_tools/mod_k2_tools.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
25	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
24	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:175
23	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
22	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
21	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
20	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
19	JHtmlContent::prepare()	Same as call in the line below.
18	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
17	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
16	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/swp/html/com_k2/default/tag.php:26
15	include JROOT/templates/swp/html/com_k2/default/tag.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_k2/views/view.php:35
12	K2View->display()	JROOT/components/com_k2/views/itemlist/view.html.php:1460
11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 19.19 ms After last query: 0.14 ms Query memory: 0.048 MB Memory before query: 4.113 MB Rows returned: 354

SELECT tag.name, tag.id
            
  FROM eygea_k2_tags as tag
            
  LEFT JOIN eygea_k2_tags_xref AS xref 
  ON xref.tagID = tag.id
            
  WHERE xref.itemID IN (16,17,18,19,20,21,22,23,24,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,63)
                
  AND tag.published = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xref	ALL	tagID,itemID	NO INDEX KEY COULD BE USED	NULL	NULL	429	Using where
1	SIMPLE	tag	eq_ref	PRIMARY,published	PRIMARY	4	swp_db.xref.tagID	1	Using where

Profile

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.09 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	1.10 ms
End of update loop	0.02 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.02 ms
Updating status	0.13 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
28	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_k2_tools/helper.php:287
27	modK2ToolsHelper::tagCloud()	JROOT/modules/mod_k2_tools/mod_k2_tools.php:85
26	include JROOT/modules/mod_k2_tools/mod_k2_tools.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
25	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
24	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:175
23	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
22	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
21	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
20	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
19	JHtmlContent::prepare()	Same as call in the line below.
18	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
17	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
16	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/swp/html/com_k2/default/tag.php:26
15	include JROOT/templates/swp/html/com_k2/default/tag.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_k2/views/view.php:35
12	K2View->display()	JROOT/components/com_k2/views/itemlist/view.html.php:1460
11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

40 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

12 × SELECT COUNT(*) 
  FROM eygea_k2_items

2 × SELECT i.`imageid`, i.`fileurl`, i.`width`, i.`height`, i.`filesize`, COALESCE( c.`title`, ( SELECT  md.`textvalue` 
  FROM `eygea_sigplus_property` AS mp 
  INNER JOIN `eygea_sigplus_data` AS md 
  ON mp.`propertyid` = md.`propertyid`

2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `eygea_extensions`

2 × SELECT * 
  FROM eygea_k2_categories

2 × SELECT COUNT(*) 
  FROM eygea_k2_comments

1 × SELECT i.`fileurl`, i.`imageid` 
  FROM `eygea_sigplus_image` AS i 
  INNER JOIN `eygea_sigplus_folder` AS f 
  ON i.`folderid` = f.`folderid` 
  INNER JOIN `eygea_sigplus_hierarchy` AS h 
  ON f.`folderid` = h.`descendantid`

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM eygea_modules AS m 
  LEFT JOIN eygea_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN eygea_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT `folderid`, `foldertime`, `entitytag` 
  FROM `eygea_sigplus_folder`

1 × SELECT viewid 
  FROM eygea_sigplus_view

1 × SELECT `data` 
  FROM `eygea_session`

1 × SELECT `langid` 
  FROM `eygea_sigplus_language`

1 × SELECT `countryid` 
  FROM `eygea_sigplus_country`

1 × SELECT DISTINCT MONTH(created) as m, YEAR(created) as y 
  FROM eygea_k2_items

1 × SELECT id                         
  FROM eygea_k2_categories

1 × SELECT i.*, c.name AS categoryname, c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams 
  FROM eygea_k2_items AS i RIGHT JOIN eygea_k2_categories AS c 
  ON c.id = i.catid

1 × SELECT i.id 
  FROM eygea_k2_items as i 
  LEFT JOIN eygea_k2_categories c 
  ON c.id = i.catid

1 × SELECT id 
  FROM eygea_k2_categories

1 × SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM eygea_k2_users

1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM eygea_fields AS a 
  LEFT JOIN `eygea_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN eygea_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN eygea_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN eygea_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN eygea_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `eygea_fields_categories` AS fc 
  ON fc.field_id = a.id

1 × SELECT `session_id` 
  FROM `eygea_session`

1 × SELECT `g`.`id`,`g`.`title` 
  FROM `eygea_usergroups` AS g 
  INNER JOIN `eygea_user_usergroup_map` AS m 
  ON m.group_id = g.id

```
1 × SELECT * 
  FROM `eygea_users`
```
```
1 × SELECT FOUND_ROWS()
```
```
1 × SELECT id 
  FROM eygea_k2_tags
```

1 × SELECT id, name 
  FROM eygea_k2_tags

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `eygea_assets`

1 × SELECT id, home, template, s.params 
  FROM eygea_template_styles as s 
  LEFT JOIN eygea_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

```
1 × SELECT * 
  FROM eygea_languages
```

1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM eygea_menu AS m 
  LEFT JOIN eygea_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM eygea_extensions

1 × SELECT b.id 
  FROM eygea_usergroups AS a 
  LEFT JOIN eygea_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 × SELECT id, rules 
  FROM `eygea_viewlevels

1 × SELECT tag.name, tag.id             
  FROM eygea_k2_tags as tag             
  LEFT JOIN eygea_k2_tags_xref AS xref 
  ON xref.tagID = tag.id

OTHER Tables:

1 × INSERT INTO `eygea_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'6462343866616430353031363032633066656538343331326236656331383536', 1, 1731965251, 0, '', 0

1 × UPDATE `eygea_extensions` 
  SET `params` = '{\"mediaversion\":\"e847631780eb8af7fe3f48cb686f5bde\"}'

1 × /* Frontend / K2 / Items */ SELECT SQL_CALC_FOUND_ROWS i.*, c.name AS categoryname, c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams 
  FROM eygea_k2_items AS i 
  INNER JOIN eygea_k2_categories AS c 
  ON c.id = i.catid

1 × SHOW FULL COLUMNS 
  FROM `eygea_k2_categories

1 × SHOW FULL COLUMNS 
  FROM `eygea_users

```
1 × START TRANSACTIO
```
```
1 × COMMI
```